/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80300 (8.3.0)
 Source Host           : localhost:3306
 Source Schema         : packagingrobot

 Target Server Type    : MySQL
 Target Server Version : 80300 (8.3.0)
 File Encoding         : 65001

 Date: 13/06/2025 02:12:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for plc_info
-- ----------------------------
DROP TABLE IF EXISTS `plc_info`;
CREATE TABLE `plc_info` (
  `Id` varchar(100) NOT NULL,
  `OrderNum` int DEFAULT NULL,
  `Name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `CpuType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `IpAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Rack` int DEFAULT NULL,
  `Slot` int DEFAULT NULL,
  `Timeout` int DEFAULT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of plc_info
-- ----------------------------
BEGIN;
INSERT INTO `plc_info` (`Id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `CpuType`, `IpAddress`, `Rack`, `Slot`, `Timeout`) VALUES ('1754784256', 0, '包装机器人', '2025-06-13 01:31:48', '2025-06-13 01:31:48', 'S71500', '10.10.10.100', 0, 1, 500);
INSERT INTO `plc_info` (`Id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `CpuType`, `IpAddress`, `Rack`, `Slot`, `Timeout`) VALUES ('1755030016', 0, '输送带', '2025-06-13 01:32:43', '2025-06-13 01:32:43', 'S71500', '192.168.70.20', 0, 1, 1000);
INSERT INTO `plc_info` (`Id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `CpuType`, `IpAddress`, `Rack`, `Slot`, `Timeout`) VALUES ('1762398720', 0, '打标机', '2025-06-13 02:02:41', '2025-06-13 02:02:41', 's71500', '10.21.10.10', 0, 1, 5000);
INSERT INTO `plc_info` (`Id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `CpuType`, `IpAddress`, `Rack`, `Slot`, `Timeout`) VALUES ('1764172288', 0, '22', '2025-06-13 02:09:58', '2025-06-13 02:09:58', '22', '22', 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for plc_info_variables
-- ----------------------------
DROP TABLE IF EXISTS `plc_info_variables`;
CREATE TABLE `plc_info_variables` (
  `id` int NOT NULL,
  `OrderNum` int DEFAULT NULL,
  `Name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `ModifiedDate` datetime DEFAULT NULL,
  `VariableAddress` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `VariableName` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `AccessType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `IntervalTime` int DEFAULT NULL,
  `DataAcquisitionType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `PlcGroup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of plc_info_variables
-- ----------------------------
BEGIN;
INSERT INTO `plc_info_variables` (`id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `VariableAddress`, `VariableName`, `AccessType`, `IntervalTime`, `DataAcquisitionType`, `PlcGroup`) VALUES (1, 1, 'TestPLcInfo', '2025-06-12 20:07:49', '2025-06-12 20:07:49', 'DB1.DBD0', 'TestPLcDB', '读写', 1000, '自动', '测试');
INSERT INTO `plc_info_variables` (`id`, `OrderNum`, `Name`, `CreatedDate`, `ModifiedDate`, `VariableAddress`, `VariableName`, `AccessType`, `IntervalTime`, `DataAcquisitionType`, `PlcGroup`) VALUES (2, 3, 'TestPLcInfo222', '2025-06-12 20:08:12', '2025-06-12 20:08:27', 'DB1.DBD0', 'TestPLcDB', '读写', 1000, '自动', '测试');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
